﻿CREATE TABLE [dbo].[AccountsPayable] (
    [BillNo]      VARCHAR (30)    NOT NULL,
    [Category]    INT             NOT NULL,
    [PayDate]     DATETIME        NOT NULL,
    [Employee]    VARCHAR (20)    NULL,
    [ReferenceNo] VARCHAR (30)    NOT NULL,
    [Amount]      NUMERIC (15, 2) NOT NULL,
    [Account]     VARCHAR (30)    NULL,
    [EntryDate]   DATETIME        NULL,
    [Remark]      VARCHAR (100)   NULL,
    [RecordId]    INT             IDENTITY (1, 1) NOT NULL
);

